Articles by Falko Timme

Falko Timme

About Falko Timme

Falko Timme is an experienced Linux administrator and founder of Timme Hosting, a leading nginx business hosting company in Germany. He is one of the most active authors on HowtoForge since 2005 and one of the core developers of ISPConfig since 2000. He has also contributed to the O'Reilly book "Linux System Administration".

  • How To Set Up Database Replication In MySQL

    Author: Falko Timme • Tags: , • Comments: 61

    How To Set Up Database Replication In MySQL This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

    read more... | PDF view as pdf

  • How To Set Up A Load-Balanced MySQL Cluster

    Author: Falko Timme • Tags: , • Comments: 23

    How To Set Up A Load-Balanced MySQL Cluster This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

    read more... | PDF view as pdf

  • How To Back Up MySQL Databases Without Interrupting MySQL

    Author: Falko Timme • Tags: , , • Comments: 10

    How To Back Up MySQL Databases Without Interrupting MySQL This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you don't do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.

    read more... | PDF view as pdf

  • Setting Up Master-Master Replication With MySQL 5 On Debian Etch

    debian Author: Falko Timme • Tags: , , • Comments: 6

    Setting Up Master-Master Replication With MySQL 5 On Debian Etch Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you don't have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.

    read more... | PDF view as pdf

  • Merging Multiple Apache Access Logs Into One Overall Access Log

    Author: Falko Timme • Tags: , , , • Comments: 3

    Merging Multiple Apache Access Logs Into One Overall Access Log Let's assume you have a web application that runs of a cluster of Apache nodes. Each node generates its own Apache access log from which you can generate page view statistics with tools such as Webalizer or AWStats. Obviously you do not want to have page view statistics for each Apache node, but overall page view statistics. To achieve this, we must merge the access logs from each node into one overall access log that we can then feed into Webalizer or AWstats. There is a Perl script called logresolvemerge.pl (part of the AWStats package) that can do this for us.

    read more... | PDF view as pdf

  • Installing Songbird 0.3 Developer Pre-Release On Ubuntu 7.10 (Gutsy Gibbon)

    Author: Falko Timme • Tags: , • Comments: 1

    Installing Songbird 0.3 Developer Pre-Release On Ubuntu 7.10 (Gutsy Gibbon) This guide shows how to install the Songbird media player (0.3 Developer Pre-Release) on an Ubuntu 7.10 (Gutsy Gibbon) desktop. Songbird is a free software audio player with media database capabilities written using XUL and VLC, with an interface similar to Apple's iTunes. From the Songbird web site: "Songbird is a desktop media player mashed-up with the Web. Songbird is committed to playing the music you want, from the sites you want, on the devices you want, challenging the conventions of discovery, purchase, consumption and organization of music on the Internet."

    read more... | PDF view as pdf

  • How To Upgrade Your Desktop From Ubuntu Studio 7.04 To 7.10

    Author: Falko Timme • Tags: , • Comments: 0

    How To Upgrade Your Desktop From Ubuntu Studio 7.04 To 7.10 This guide shows how you can upgrade your desktop from Ubuntu Studio 7.04 to Ubuntu Studio 7.10.

    read more... | PDF view as pdf

  • How To Upgrade Your Desktop From Ubuntu 7.04 (Feisty Fawn) To 7.10 (Gutsy Gibbon)

    Author: Falko Timme • Tags: , • Comments: 4

    How To Upgrade Your Desktop From Ubuntu 7.04 (Feisty Fawn) To 7.10 (Gutsy Gibbon) This guide shows how you can upgrade your desktop from Ubuntu 7.04 (Feisty Fawn) to Ubuntu 7.10 (Gutsy Gibbon).

    read more... | PDF view as pdf

  • Automated Backups With rdiff-backup

    Author: Falko Timme • Tags: • Comments: 12

    Automated Backups With rdiff-backupThis tutorial describes how to do automated server backups with the tool rdiff-backup. rdiff-backup lets you make backups over a network using SSH so that the data transfer is encrypted. The use of SSH makes rdiff-backup very secure because noone can read the data that is being transferred. rdiff-backup makes incremental backups, thus saving bandwidth.

    read more... | PDF view as pdf

  • Server Monitoring With munin And monit On Fedora 7

    fedora Author: Falko Timme • Tags: , • Comments: 3

    Server Monitoring With munin And monit On Fedora 7 In this article I will describe how you can monitor your Fedora 7 server with munin and monit. munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix and takes the appropriate action such as a restart if it finds a service is not behaving as expected. The combination of the two gives you full monitoring: graphics that lets you recognize current or upcoming problems (like "We need a bigger server soon, our load average is increasing rapidly."), and a watchdog that ensures the availability of the monitored services.

    read more... | PDF view as pdf

Page 132 of 146